SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504013 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504013 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747612,595779,705999,978917,336462,250219,538884,463961,473278,419535,204487,199450,574537,808911,61567,144584,232900,212176,918164,712533,869599,820319,818842,198155,585605,44638,196087,925699,117809,242278,833133,88816,320508,159758,335385,738452,997943,237958,944075,415449,538971,400775,539252,752296,955453,229679,899109,501279,92539,222887,544724,824156,675893,598598,271793,485167,515586,227452,906057,361710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]