SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556716 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556716 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294996,113973,256660,631053,869262,776135,642257,137189,695618,811635,539829,948719,132995,985495,417277,1020482,1043112,906560,797320,487837,228543,791978,521078,476708,403680,368000,417144,304141,774367,354504,653012,930972,865042,707352,778226,170719,827347,657508,261084,985569,892544,581931,766279,490013,1014404,932062,827107,77401,867917,271939,896111,417342,488530,791004,113781,668197,229866,48352,724970,297382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001799s ]