SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802744 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802744 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495225,304329,1020733,516791,515556,319186,1044921,603996,63740,232313,678131,766921,588986,849038,201721,492041,1010640,431767,335461,702777,199814,713809,733446,492585,249150,723018,379972,119723,928671,844911,784761,1037901,308202,49776,45017,284256,906969,400016,329628,635751,707466,1019,497265,121142,246237,271066,310193,1048904,492480,705792,515805,781700,1002034,312536,375109,852324,719283,266243,1002983,650302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802744 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802744 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]