SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521300 LIMIT 1 [ RunTime:0.000689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521300 [ RunTime:0.003510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677513,1027803,566453,335116,948321,577424,56739,737185,41897,173509,397893,747801,808681,855734,608924,655557,450968,910992,743535,44255,194704,684207,371660,657572,814371,357060,731,150730,199862,585963,20338,935144,562152,598046,917225,820474,203192,262184,886397,490052,484817,398153,646415,441907,1030448,779488,352223,801755,662373,414765,344654,1009634,307334,717377,194068,875601,794550,715464,1022032,990907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]