SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328104 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328104 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678797,629371,1036953,234424,986664,192535,983454,141085,116011,69912,973906,877494,71989,237997,1023244,702683,127948,868008,97541,233444,719232,399243,354670,432428,891250,518340,26203,339813,806667,412954,716610,964034,204154,977449,197473,963865,949542,166599,189150,114705,219048,863513,14591,617768,538826,159839,493073,125175,64860,289700,943518,737999,706562,640205,1046355,446687,857514,603678,140489,381200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]