SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416185 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416185 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47346,921891,76783,958260,92329,133814,376047,115216,1001284,215214,1008621,284511,380392,501057,817690,980970,632443,394065,944142,79369,168705,74004,1014061,619178,52950,195570,304165,732270,670674,228102,302736,219911,527269,216893,198700,1026262,128110,575381,698937,830419,290632,1041486,436264,396963,955094,966891,254052,618966,415911,735174,36944,933395,53833,699398,495474,163773,432535,100959,838739,665548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]