SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 731213 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 731213 [ RunTime:0.003090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185391,407019,963176,107414,853183,50646,515126,89438,1037715,1018772,652842,841431,743146,703254,49944,641963,211107,593101,654038,263249,155976,58977,703085,987155,517689,976550,974269,704142,936495,947923,762853,469605,287334,298849,1003815,642044,854458,991372,775311,163275,815800,165733,802525,405086,388463,274716,246697,998010,395578,783314,681570,673248,48285,128402,170027,574505,52492,943651,1032488,1010701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 731213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 731213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]