SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599876 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599876 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601200,447246,576091,432174,971305,435858,830598,77490,87500,568544,435491,938652,301902,682474,111585,700682,320289,1028076,690927,34199,846998,174996,593273,845935,692571,665815,126631,502941,325660,212737,894550,248796,339898,648913,873858,888408,477827,358771,1034163,371215,774571,20369,945481,637345,680699,1030425,192295,336550,741940,865785,515136,839497,136518,895579,324114,635976,831324,276887,100399,715758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]