SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520831 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520831 [ RunTime:0.002466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385221,773137,527893,452759,91583,175533,897752,816380,1014794,416575,539186,771730,910597,111154,626137,152259,745275,447456,415541,52975,650334,880471,253141,481261,742063,579223,785149,687409,678711,149840,403112,280459,1037571,65359,747732,544566,984404,305677,1005979,909999,897512,355344,759989,66127,689898,1039549,472198,742064,104815,893690,590906,816915,899826,220822,782134,1011962,842548,416285,980877,384960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]