SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364215 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364215 [ RunTime:0.002775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563612,1033283,456267,968349,292192,189017,118643,191780,776955,801837,223396,315893,878750,504679,1041070,726081,168773,849414,12813,205646,454185,247568,429805,1043027,97210,1005748,801771,58782,7124,261139,256819,329638,738495,138583,540526,474141,1020810,366942,669015,479103,410306,643178,385413,647557,424193,771912,861234,823780,398410,273400,693098,129893,1048117,912032,926970,1040273,198150,876687,525524,502778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]