SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492008 LIMIT 1 [ RunTime:0.000871s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492008 [ RunTime:0.003782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199421,271332,159177,468366,1001618,130661,210001,115646,277825,87828,464131,473782,522043,971981,970738,1014305,883683,950389,50774,268315,722056,780570,1008676,504562,958421,196319,739194,102370,64278,811785,217657,92799,562783,860215,506535,451796,957769,516075,566904,762947,935455,3154,882819,250344,687217,420675,282493,88628,1030574,307767,386522,321511,906231,631590,232861,667522,331051,812204,731610,159146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]