SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393726 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393726 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269850,1001997,756250,75750,214944,362565,367176,471219,859622,894142,300842,987635,793764,116195,453302,1045177,662706,279321,199768,21043,245451,505778,543239,92901,541487,682708,406396,809266,690116,917569,733759,246893,882170,830712,639827,521006,438879,965800,866525,413357,832281,956643,804862,68607,814881,194249,801676,1014598,693708,635285,131042,1000808,734442,222400,1022090,698422,779155,247392,513914,805096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]