SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409870 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409870 [ RunTime:0.003436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89445,495688,130618,1003202,345449,885826,900012,790191,460697,767151,1027617,632035,404019,685260,909349,1035202,758276,389181,645486,835242,17520,196020,959692,572579,182857,244323,967110,136616,780113,161537,86790,34154,865811,353601,331690,726190,26995,481952,740385,956171,919319,330115,250116,349529,887938,574761,431336,90439,50644,570739,174755,177622,350519,846749,321727,56497,675566,457864,103490,909040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]