SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541515 LIMIT 1 [ RunTime:0.000274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541515 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120614,662257,191603,406170,29814,626938,693489,357028,157092,287614,164115,185235,405055,359615,188857,202461,312986,801076,865197,68017,933168,405741,647190,913156,75929,199536,505016,185264,664792,561117,419595,773048,770805,582346,4585,829325,58330,719845,277055,77016,1047914,546289,782149,980893,754206,147583,229603,762027,777213,268190,119990,564134,241080,345296,862076,475304,894692,354991,837323,80249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]