SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681109 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681109 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437595,474393,320377,768347,356242,395070,756022,632099,688247,368566,366383,919214,865443,830008,292876,622053,773669,25184,433885,422872,465726,642047,926949,214250,154026,561215,989130,440110,219559,233892,795281,870376,927118,686694,114167,516107,841213,9809,67193,897625,276821,593507,822588,791068,702278,798332,196534,677582,91948,458831,275047,418240,602267,830851,56346,744340,107090,766865,764262,253563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]