SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514017 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514017 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86854,342834,420868,208476,871032,397493,678728,848592,154679,265638,23255,249368,806088,70918,976308,310272,668935,161698,618998,615412,191819,1003651,560006,497891,447466,89657,488181,750464,478351,644296,10109,88772,407159,1001098,171855,259305,905071,1026962,162036,158007,636802,157360,939936,772950,206826,280957,929060,439802,699642,672229,349953,281117,254928,597151,866109,864468,546125,65980,633749,510577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]