SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901214 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901214 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592329,129409,987199,801423,453911,772929,383629,390146,220778,300845,1009401,820474,779336,292254,522303,381397,288018,724049,16610,389209,246980,155426,886752,307187,841631,85683,688914,126179,903117,419808,233808,193219,794753,920083,694556,621961,880651,718840,852543,24528,416484,997214,682168,362485,616292,604907,718008,968355,1027107,363725,824038,800174,12458,522248,947572,417816,791887,210335,1040044,760533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]