SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457482 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457482 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186528,1031416,942556,215727,214009,506561,452534,773797,805003,228887,672177,143070,207704,262636,760646,593800,747895,212921,962459,935854,793127,948070,681662,486773,553945,155221,965139,741877,706497,823694,89754,75074,867859,427275,634835,247606,837632,679876,357628,606638,647591,514180,211638,276677,127734,351071,625095,7556,117897,153144,904529,961326,670100,227473,706567,700259,702984,942759,947651,917219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]