SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558512 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558512 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615450,550676,987993,432003,187708,1039150,807182,520931,447811,848417,44896,280340,565666,407852,995561,733407,899284,287446,340651,885185,894664,824927,32989,7174,284532,654575,81988,341481,138369,245324,851514,510583,514704,391838,833503,44649,771418,642704,799288,949664,323737,755025,73481,853960,168960,188950,35322,497885,333701,916389,154418,301086,630087,411400,418418,724346,777187,435131,248058,1027867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000999s ]