SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019819 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019819 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835188,816103,518875,278476,292437,1017331,464590,603044,857367,50294,943797,933145,252045,188844,1020074,2407,122893,167929,343263,693980,211384,482554,780048,781028,156110,351940,91347,844079,207865,976957,42681,664236,1006580,819134,481888,463371,510920,72246,977503,77792,620340,184846,811996,660629,998199,795973,945834,272176,374474,53589,626363,1037411,945937,507199,148588,304801,365033,75005,66402,146270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]