SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507023 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507023 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474689,50687,557536,463046,246459,437055,125819,808592,298158,104677,384523,703498,7274,97379,493342,806294,988503,108744,827567,475508,199922,83000,688548,489295,59629,541070,174910,207985,807064,707464,956612,935409,939947,38289,39355,751681,812508,596564,900146,194106,291518,537851,814301,971528,346714,508004,901112,236731,226045,46141,430130,389119,1005453,192681,1007811,665150,93918,410535,474142,907913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]