SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521286 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521286 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334315,961024,439492,567964,840621,207343,888639,347820,840896,539112,709897,249921,67294,1010110,135568,649296,729004,1004457,417470,941005,1035175,500166,623664,551181,1020781,243146,835159,318737,670173,49909,783005,766348,261314,749336,940258,305906,751811,918499,246163,493366,314860,721490,252565,261814,874408,833073,736230,1001314,764331,47045,356825,827563,658716,1019964,802256,189172,586412,664500,258926,840184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521286 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521286 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]