SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802284 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802284 [ RunTime:0.002636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639060,540450,601620,1046186,809833,1019908,316192,521137,664471,9404,291768,860040,928612,205998,612481,150442,656252,25337,346136,378610,911863,874443,489516,277119,498889,162589,815007,1025607,893506,385321,809475,482699,268410,678928,253633,731352,56543,1026575,57852,764609,191800,449796,83506,152615,723458,373389,649243,22995,1017301,902941,694308,727568,151240,480996,955284,748822,477043,354864,157705,319129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]