SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001559s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49913 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49913 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156232,401370,386355,345486,390891,809586,79022,463603,155642,303188,147313,591356,1018866,253480,832913,248955,426093,571450,679499,522943,6520,605035,815066,53485,1007195,741439,736521,94187,751467,80468,278256,481205,806497,793927,108697,324168,724870,928675,76422,489775,102053,315079,779576,433759,265180,982151,254777,995642,718144,929738,906672,785784,636809,253282,901553,127764,265288,847760,466840,49126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]