SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503300 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503300 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173927,793819,86355,429460,211786,271147,870854,274022,685766,265157,537767,703412,978471,330352,831041,269858,413226,845012,674718,980778,737727,529079,798319,273297,341672,40361,95943,837879,120445,372221,560960,750393,532000,611039,848793,674998,553717,816995,240761,875054,40674,786882,299533,485448,764825,748570,488367,83878,116413,207465,18797,553466,74512,264937,234693,617296,979238,505201,465729,973535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]