SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457758 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457758 [ RunTime:0.002359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80521,954986,752384,710621,706088,68505,1007299,772478,712766,491006,888309,771790,707146,95233,579716,687955,115285,113008,381614,488709,850029,771401,928217,542343,976224,523505,848739,837465,214154,639903,778293,928450,433059,35458,684174,82007,356628,271624,602137,446997,606436,255931,653712,926687,954893,445515,981712,95448,98055,878096,187403,235938,73983,941642,671814,861537,192302,734209,211065,425148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000750s ]