SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507721 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507721 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931858,96704,110338,94643,989251,965147,938818,210063,261561,938442,480177,372532,493099,950438,162098,76706,698112,92523,959027,429660,381188,528066,917623,601601,152869,59161,495721,752832,932089,275053,7682,756103,914101,1015248,182506,400342,790978,640462,140918,374018,827937,456987,84670,1023974,368348,1024523,144554,528205,258966,121963,620689,625079,1035577,43729,256033,84186,53901,794563,391709,241345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]