SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68440 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68440 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321701,826132,540267,1048308,820561,551589,780346,331876,429858,1009065,941208,723023,287299,662556,869880,78495,912339,279602,62059,686064,670194,140373,181576,779943,304010,650741,1042205,785308,756361,677523,26729,877958,621204,159062,239532,918683,694422,666278,524398,385697,403209,156259,881792,325044,202039,782705,743092,748902,303586,449079,543968,379352,392889,523121,323213,933102,1024326,558033,564608,258589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001617s ]