SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544515 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544515 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228621,264881,166858,88289,35251,514508,573674,626195,294622,87567,422658,153166,114448,316017,401610,221673,905391,294237,1038509,854668,666240,1041509,504662,337165,602704,19428,731500,824436,656485,206957,553982,122587,130471,180575,784216,792337,602691,242920,536450,195726,217771,44350,545800,147288,705874,376872,904637,815709,147663,842047,958508,450342,158893,348576,226,350889,966010,687190,137270,905705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000857s ]