SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449407 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449407 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876910,15528,89087,543267,423297,192822,620757,208723,618369,531614,562550,796531,333569,894286,321201,1031219,715130,87,673543,764395,963097,176656,774064,121861,995411,1039956,605158,93012,21975,406252,979644,465613,468446,547029,625244,521447,604832,769613,543869,921263,252748,914594,173792,471900,377069,306840,134062,517208,143718,950367,390108,923244,659519,840207,823065,225707,431409,1046615,879576,191294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]