SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419814 LIMIT 1 [ RunTime:0.001129s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419814 [ RunTime:0.002679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759694,117853,6624,306343,311277,989268,169192,939830,693163,581359,1043970,490148,332492,602689,789465,1020850,273983,940409,410304,991099,706633,757945,344698,418806,137413,358679,1041430,234789,820814,420746,1010903,427425,278050,944533,867437,1029393,407522,460872,754152,278576,431531,917469,753274,742160,373569,208319,747905,342476,889011,99701,910945,390953,572815,448975,838341,576044,908433,387721,17995,192934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002331s ]