SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429724 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429724 [ RunTime:0.003383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500486,935565,416417,1020847,379528,75887,663048,1017259,692413,63420,910581,406674,960959,869482,494058,600544,179927,1044182,792234,308067,351924,513873,614614,987214,700448,1034042,1012023,361066,161023,310223,782208,755965,631896,6463,560438,588984,312468,859587,394933,470432,743803,331084,988881,347433,756651,106736,480567,352053,987894,65334,824525,566330,831776,665618,507605,948679,612786,432125,916837,42669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429724 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429724 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]