SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437470 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437470 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563972,311892,301116,603096,1048263,185179,461296,312276,170918,489330,376784,151602,537240,906597,216915,887037,822223,60602,616951,1023850,892406,667262,226031,944010,212043,168014,298726,802428,161421,172622,591346,20890,573462,543767,171228,365888,181190,80090,390086,11247,608114,451700,709882,321617,434709,450676,883311,350590,468437,479958,143388,542828,265615,261377,274492,134988,826531,996337,7221,572674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]