SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405094 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405094 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786403,279012,150179,219302,990082,834639,1024171,182800,903804,746276,659864,524407,61137,91285,1035854,797176,1038838,258234,901752,527380,754426,256867,516284,855388,179344,786926,36102,865298,521872,679551,154137,355767,432735,248633,827004,121708,965573,863305,629671,481526,478239,884950,403801,518152,207849,590809,942274,542872,780409,212162,395441,444149,627836,1025149,946108,62994,814128,365748,357164,486108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]