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` = 537057 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537057 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526928,770428,166342,877590,503118,427361,714583,692352,388559,749210,777794,671239,153623,196168,987382,632169,738368,813430,456485,1023381,423541,476349,485576,925855,1043148,157792,230556,813406,474933,517408,1046210,535816,495251,69517,452229,383740,870012,701207,249567,403559,676170,386604,809781,28035,189648,337068,997079,478291,265828,941691,741620,251933,530577,152040,802662,936391,966059,555248,77551,1001063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537057 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537057 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]