SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 122928 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 122928 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63553,5079,848612,72869,735627,413947,158173,84403,121033,429373,1010411,129853,843770,305818,957881,829867,881622,757732,920292,88960,573242,1002425,723941,410410,605267,106877,642613,536517,507254,545087,895488,310044,973374,684876,610361,172288,220982,1039035,960874,210180,996992,812460,503208,660196,357283,864111,1035698,281047,178374,798898,1033968,826836,11741,698633,110301,655929,206878,439434,803084,133404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 122928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 122928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]