SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195092 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195092 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29236,527441,685988,767872,586301,261543,956936,992094,542446,277574,675039,389054,667937,371888,636230,627926,768260,749536,884213,968929,1023076,857744,210871,460043,75549,715467,508227,985690,200897,916554,988905,409446,866424,842533,875434,810229,623506,377848,197768,888830,528274,134692,710325,704145,86722,943478,81629,98348,447320,137078,246595,952414,437112,45297,1006821,89803,375152,151619,245101,391852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]