SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 762851 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 762851 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203689,136278,141503,133704,890160,261398,968208,54524,208864,1043596,411625,333163,969061,534128,586287,953167,389540,505148,843985,991900,947534,562181,513821,82426,424756,388391,756965,334009,805785,43399,305432,730975,190782,194315,38247,326717,671708,178732,1012716,53597,163072,817551,495252,137490,334483,860475,1019188,444498,59429,89488,1016211,306131,1043305,252724,855891,619375,497484,328986,797540,555179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 762851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 762851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]