SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40070 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40070 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562484,682717,116200,433931,49953,986511,1039441,129486,326836,185209,949299,1035947,819265,763795,381674,622967,795163,442428,188182,276795,738326,140102,303793,268591,751212,829184,250271,203272,844392,233552,495689,526057,302050,774743,690881,771088,513942,995942,321552,539225,1029006,1036109,981494,92950,435959,983396,37847,72439,453422,1008530,282204,1033104,418471,736572,1018302,135219,465802,647584,835127,503909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]