SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560570 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560570 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718718,306910,444272,947062,179660,976010,847977,322274,162394,580495,291989,24518,658225,142728,731748,386291,327679,57890,235127,502312,1033004,217489,372575,456152,319164,608918,707882,217223,688645,784826,279371,247192,640917,940873,1044739,164807,307165,203649,103765,908786,249772,1044218,389029,510285,86043,233649,581349,4330,562204,732935,128540,682919,1027346,3952,610654,179018,1037371,1019756,38937,762639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]