SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019511 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019511 [ RunTime:0.002883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015640,199253,888005,499935,939430,847244,889556,410044,195552,888497,1048150,722416,127402,1003364,305803,777262,737576,857059,480304,719933,255890,419413,565995,597047,957897,634537,110118,460970,506211,755151,699479,711622,649570,930796,910298,661963,26147,445909,102606,390425,495430,887329,200990,759285,272183,307622,347145,639563,996624,68147,19536,597246,298357,523406,446774,181762,577341,883077,57308,906958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]