SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40669 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40669 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379407,785994,343817,448746,497903,156463,118026,496378,863485,960012,671151,754006,883217,854111,67452,961025,358057,260396,562002,285078,918921,527840,96134,649731,75016,493435,1035548,1035663,101769,471346,549123,849812,354869,282135,594208,907458,480524,366130,991393,9220,827907,625658,838139,242731,780851,905603,786530,561331,906973,690127,160149,712234,307655,122777,561296,1009532,869882,873724,827178,576149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40669 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40669 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]