SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404513 LIMIT 1 [ RunTime:0.001330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404513 [ RunTime:0.002647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360535,468248,203493,988878,660288,13078,310634,578422,978876,753893,706,91055,221899,45932,408328,681892,475941,846886,161596,160548,652074,292763,47492,903936,801728,914598,70022,252072,496382,145014,912226,872061,982322,987027,866527,195717,21583,580687,584595,781668,632856,583633,491060,774756,54669,229092,12029,229924,1048325,186996,590675,749955,491260,694993,127867,781873,328493,353794,191438,193858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]