SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510299 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510299 [ RunTime:0.004609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8328,349722,974641,76531,244482,493262,646621,327948,173921,403369,52170,714801,1038592,182065,54839,37860,997647,126401,885181,1041038,282548,177324,52946,954763,226988,977730,806124,890926,694045,162757,188657,692584,967766,681953,192571,380025,924171,103617,135398,671408,435177,43748,755052,962024,189298,309587,891868,54346,33703,467903,817955,516540,883379,736111,448987,1045086,35980,612598,985811,21430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]