SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110400 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110400 [ RunTime:0.003224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3905,343606,608043,906448,770027,386733,671549,302065,571265,484738,1021213,899962,193347,502055,654651,892559,1029160,172243,149872,347405,159147,183187,495818,44021,643692,473613,422295,407890,953217,596399,603412,291691,733589,443263,557491,714848,370215,65108,815821,999947,827285,177482,938285,323671,1019907,81641,827556,575321,671036,781079,268877,798633,469636,57087,374476,974416,438605,204875,428509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]