SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011566 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011566 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294098,785590,1044607,234691,176056,972603,312857,448795,274596,367563,739397,200714,268473,593541,488593,42523,789610,441020,208472,816042,694211,454446,1017585,82494,732217,172937,984542,163776,895249,807414,722691,763948,321954,628907,259742,538109,34125,689275,203301,73124,995812,57664,842792,76050,428993,752807,963464,111274,756898,1012622,802600,575181,425398,387724,262192,665808,301604,181758,723518,475442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]