SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142156 LIMIT 1 [ RunTime:0.001677s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142156 [ RunTime:0.004259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252431,156193,427804,626489,109419,774884,845573,321502,1030174,798307,746442,947531,1025513,278358,165489,616739,176726,689385,76520,272006,853839,472230,529456,886398,116118,832752,475889,981909,59268,450296,124011,1740,565875,297387,176087,222456,249679,51705,834057,957420,594968,365150,549520,889766,61204,791399,103889,14779,1006015,239041,114381,180542,320887,954864,606125,1020504,307116,582272,516436,988563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003205s ]