SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 988910 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 988910 [ RunTime:0.002939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156250,351991,944634,267227,118060,1006336,881869,899039,263811,247552,842276,664109,696122,323823,70236,580948,512710,1037944,828577,653347,644501,474341,749677,494155,286680,525190,203565,7199,701411,859678,285276,820935,319289,988606,889387,945056,810170,361353,23802,2801,534400,386101,560821,845481,386040,631886,966863,207717,651792,60127,415481,634790,706993,928833,968196,653765,662366,860237,660261,768069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 988910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 988910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001134s ]