SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380050 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380050 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929285,944220,782180,535237,919243,64135,236354,926124,33410,129646,1021914,815821,564762,39132,756929,951462,263884,899833,388163,481488,21750,827104,336436,1027922,910238,409219,409122,983209,525179,105501,720692,347783,576748,480292,416045,968590,903077,190884,892713,259450,746318,700087,372387,322263,1019417,887900,397691,618958,887779,613312,362360,444138,380407,279573,277092,381339,726230,993916,686844,296830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]