SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432872 LIMIT 1 [ RunTime:0.001450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432872 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431589,615865,1043541,700750,117955,406412,205913,610832,901902,769273,14756,778023,1030637,250219,928219,814753,800000,1039110,510506,239865,239903,388821,430291,1031544,487663,486511,163073,840352,189262,1024293,156845,682072,453356,196984,889425,418509,853980,703810,699311,1045780,23433,961879,581111,94995,985908,32302,993243,992256,168719,777160,872623,938316,502078,435848,206573,704441,779987,553178,1028930,579940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001088s ]