SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002771s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401722 LIMIT 1 [ RunTime:0.000875s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401722 [ RunTime:0.006672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292194,726291,632839,928767,470500,734245,435251,188470,856452,120932,364439,363960,366507,761474,992418,484862,580219,453375,30261,106608,212529,474653,475894,165953,988314,91862,464271,954452,415873,752766,355094,1040929,12823,735857,760799,315334,158729,43393,827782,519148,642643,586459,416909,151807,521105,171786,263039,372393,892712,380545,113814,619640,988284,384252,909837,911481,252922,718937,722950,37022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]