SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 747308 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 747308 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39641,46982,25750,28203,1006415,583651,82231,994204,616056,660118,881672,1047358,702119,267191,218795,860664,112356,1027389,200235,238443,596278,909976,305031,18442,508656,801989,172498,183600,910524,979841,106536,437570,664547,578969,707446,849073,253993,20617,108038,129686,531646,638165,397737,975980,210456,73379,442689,853915,827404,368472,194207,705507,86534,101394,863467,514393,318607,852182,475923,407958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 747308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 747308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]