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` = 477910 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477910 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197542,968475,224255,54004,235451,570336,959893,35240,912403,1004577,726130,433437,938740,1037479,872130,371093,66552,409121,181771,98289,190880,159847,937277,939908,427941,320350,23408,253228,641588,738733,394006,925170,150249,702237,246112,335621,976697,1004221,536140,845781,327272,627608,288084,173839,353816,64211,304927,706477,682409,927321,82342,920797,925294,500948,727019,338225,808735,992229,858234,486468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]