SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001570s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287540 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287540 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939039,701262,488373,940043,642537,682357,886060,591649,167149,625021,402803,345672,422730,198858,477767,203786,661898,840923,424450,129671,31430,902437,1038193,38580,802960,719981,469746,673570,391950,86418,88532,212798,572225,939141,733151,656156,101601,367204,886711,493815,496444,560628,683468,594636,92144,511161,1001515,464148,743712,895285,379090,268603,715418,908035,154983,763582,459832,22427,452929,511246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003619s ]