SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009238 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009238 [ RunTime:0.003240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252199,526707,202804,321965,439987,648866,257798,620100,510872,45020,909738,795520,1009237,1000912,337555,128644,372274,237064,703138,971971,325956,224373,611409,144939,1005628,539943,489327,1033261,602028,50307,925678,42131,666910,1012342,396585,508060,468998,512603,760659,167411,311689,838917,936043,16894,807192,696912,428309,453137,512506,531240,188377,581852,763779,716229,863335,601473,1037197,26790,533263,1044571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]