SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001559s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477510 LIMIT 1 [ RunTime:0.000569s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477510 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25479,63422,22541,218848,265378,34415,106237,963352,463352,790502,398836,439171,217414,8139,671803,29813,138020,420094,997538,926228,154394,310185,916731,411163,349903,259776,220369,838327,1048925,551619,394216,195366,92943,646305,702340,1033119,968750,836982,268695,379367,43198,757320,924966,814047,1047308,807186,419873,9399,981213,287646,704308,699784,195215,858782,73690,786315,802430,755109,38564,321548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]