SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39153 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39153 [ RunTime:0.006046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840418,514259,471710,641004,761837,29480,693116,947427,407465,682331,689991,782079,343629,1010401,924275,980292,460998,359003,248936,753378,259372,133448,479194,47415,791687,481385,517655,827389,388071,664987,534180,831555,762519,1019257,878481,310661,1041003,161887,399498,7149,708633,122166,85803,123984,659566,626413,59153,405377,642913,244381,60637,831982,314088,205486,603291,55698,186554,186354,457288,549593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]