SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310926 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310926 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355714,101335,62737,658212,1018609,328937,523722,638648,665672,93489,538905,572743,605850,129376,483543,906554,820714,856764,190738,848226,835140,535741,54471,734106,629025,287138,686840,369252,714419,561018,484940,640446,323669,766763,589747,312833,721771,188980,720268,222328,316048,824449,891119,817287,906807,202527,190075,600044,26245,1046434,901677,1007452,365706,490800,26665,379056,217662,7491,14441,709983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]