SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368011 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368011 [ RunTime:0.004251s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28520,366412,516547,523793,593254,413069,913551,936098,353079,60909,105152,42039,637250,220467,844062,926447,228581,961488,22497,419941,18791,804054,584513,605571,891849,201845,352324,877952,444931,948727,441565,305601,421030,231092,557979,231740,599458,643474,462358,890899,113840,728637,514531,834477,929443,459729,222454,169101,934081,655091,46583,191974,454188,496769,298769,435926,337588,896744,996046,753763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]