SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507001 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507001 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675884,599626,783210,683645,705309,274799,119879,1039843,950997,533620,43212,431115,205827,472824,130209,421267,310784,13624,390294,22344,273809,275148,158960,866826,625131,961636,444893,791643,643512,820515,991724,50711,823530,197478,949935,251073,214831,445188,106129,73023,960855,968810,60423,117011,485016,216875,373299,291645,942174,668425,694282,499121,2272,398877,696738,104039,732233,287905,337274,976391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]