SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030268 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030268 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021140,688289,925283,452187,519582,815613,48312,599470,376381,800676,909152,393773,729910,612685,1027762,51037,561876,682899,132195,207082,766204,660266,814103,1004120,408105,984559,217870,376304,904015,1017603,452992,291563,968493,258539,536140,83749,1042906,352441,537250,611521,546977,614056,933326,35216,201497,411961,432173,801352,791566,1030228,894143,1017783,477674,989204,628807,991459,376368,94252,100136,619097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]