SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317511 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317511 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508867,284133,503923,408030,1015078,620131,683499,686970,210673,461772,300571,372734,345480,530938,886101,290170,464634,88569,261451,945196,274011,934615,738849,47405,872718,567716,755390,452919,996053,224378,510991,576700,520284,596593,26276,22565,814879,19527,856615,755752,252799,562218,571796,728378,403784,51044,538111,780551,31604,647603,614357,881624,881663,464285,118104,348939,18828,969931,289610,128995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]